<!DOCTYPE html>
<html lang="zh" xmlns:th="http://www.thymeleaf.org">
<head>
  <th:block th:include="include :: header('导入表结构')"/>
</head>
<body class="gray-bg">
<div class="container-div">
  <div class="row">
    <div class="col-sm-12 search-collapse">
      <input id="dataSourceId" name="dataSourceId" type="hidden" th:value="${dataSourceId}"/>
      <form id="gen-form">
        <div class="select-list">
          <ul>
            <li>
              表名称：<input type="text" name="tableName"/>
            </li>
            <li>
              表描述：<input type="text" name="tableComment"/>
            </li>
            <li>
              <a class="btn btn-primary btn-rounded btn-sm" onclick="$.table.search()">
                <i class="fa fa-search"></i>&nbsp;搜索
              </a>
              <a class="btn btn-warning btn-rounded btn-sm" onclick="$.form.reset()">
                <i class="fa fa-refresh"></i>&nbsp;重置
              </a>
            </li>
          </ul>
        </div>
      </form>
    </div>

    <div class="col-sm-12 select-table table-striped">
      <table id="bootstrap-table"></table>
    </div>
  </div>
</div>
<th:block th:include="include :: footer"/>
<script type="text/javascript">
  var prefix = ctx + "tool/gen";

  $(function () {
    var options = {
      url: prefix + "/db/list",
      queryParams: queryParams,
      sortName: "createTime",
      sortOrder: "desc",
      showSearch: false,
      showRefresh: false,
      showToggle: false,
      showColumns: false,
      clickToSelect: true,
      rememberSelected: true,
      uniqueId: "tableName",
      columns: [
        {
          field: 'state',
          checkbox: true
        },
        {
          title: "序号",
          align: 'center',
          formatter: function (value, row, index) {
            return $.table.serialNumber(index);
          }
        },
        {
          field: 'tableName',
          title: '表名称',
          formatter: function (value, row, index) {
            return $.table.tooltip(value);
          }
        },
        {
          field: 'tableComment',
          title: '表描述',
          formatter: function (value, row, index) {
            return $.table.tooltip(value);
          }
        },
        {
          field: 'createTime',
          title: '创建时间',
          sortable: true
        },
        {
          field: 'updateTime',
          title: '更新时间',
          sortable: true
        }
      ]
    };
    $.table.init(options);
  });

  function queryParams(params) {
    var search = $.table.queryParams(params);
    search.dataSourceId = $("#dataSourceId").val();
    return search;
  }

  /* 导入表结构-选择表结构-提交 */
  function submitHandler() {
    var rows = $.table.selectColumns("tableName");
    if (rows.length == 0) {
      $.modal.alertWarning("请至少选择一条记录");
      return;
    }
    var data = {"tables": rows.join(), "dataSourceId": $("#dataSourceId").val()};
    $.operate.save(prefix + "/importTable", data);
  }
</script>
</body>
</html>